﻿IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'proc_cm_DeleteFileshare')
BEGIN
    PRINT 'Dropping Procedure proc_cm_DeleteFileshare'
    DROP  Procedure  proc_cm_DeleteFileshare
END
GO

PRINT 'Creating Procedure proc_cm_DeleteFileshare'
GO

CREATE PROCEDURE [dbo].[proc_cm_DeleteFileshare]
	@pFileshareId uniqueidentifier
	, @pHtmlPageId uniqueidentifier
	, @pSectionCd nvarchar(50)
AS
BEGIN
	SET NOCOUNT ON

	DELETE FROM [dbo].[tbl_fileshare] 
	WHERE [fileshare_id] = @pFileshareId AND [html_page_id] = @pHtmlPageId AND [section_cd] = @pSectionCd
END
GO

GRANT EXEC ON dbo.proc_cm_DeleteFileshare TO PUBLIC
GO

